Scalar functions to return the length of an item
Format
ANSI-SQL Format:
{ CHAR_LENGTH | CHARACTER_LENGTH | BIT_LENGTH | OCTET_LENGTH } ( expression )
ODBC Format:
{{ FN { CHAR_LENGTH | CHARACTER_LENGTH | BIT_LENGTH | OCTET_LENGTH } ( expression ) }}
Remarks
The functions CHAR_LENGTH and CHARACTER_LENGTH both return the length, in characters, of a string expression.
The function BIT_LENGTH returns the length of a string or bit string in terms of a bit count.
The function OCTET_LENGTH returns the length of a string or bit string in terms of a byte count.
The length functions are also supported in the ODBC function syntax.
Example:
CHAR_LENGTH( CurrentStateDesc )
{FN OCTET_LENGTH( CurrentStateDesc )}